Spotlight report for motif SNPs in (pos/neg method first_try)

1 Load data

df <- read.table('../../../output/first_try/report/summary_table.txt', header = T)
df$rownum <- 1 : nrow(df)

df.sub <- df[df$motif_qval < 0.05 & abs(df$r) > 0.5, ]
df.sub$strand <- as.character(df.sub$strand)
df.sub$strand[df.sub$strand == '-'] <- 'negative'
df.sub$strand[df.sub$strand == '+'] <- 'positive'
row.names(df.sub) <- NULL
motif_logo_prefix <- '../../../output/first_try/report/motif_logo/'
mash_plot_prefix <- '../../../output/first_try/report/mash_plot//mash__idx'

for(i in 1 : nrow(df.sub)) {
    motif_logo <- paste0(motif_logo_prefix, df.sub$dbname[i], '__', df.sub$motif_id[i], '.png')
    mash_plot <- paste0(mash_plot_prefix, df.sub$idx[i], '.png')
    cat('#', as.character(df.sub$gene_name[i]), as.character(df$motif_id[i]), '\n', '\n')
    df.show <- df.sub[, - which(colnames(df.sub) %in% c('idx', 'motif_from', 'motif_matched_sequence', 'motif_qval', 'dbname', 'rownum'))]
    pander(df.show[i, ])
    img1 <- rasterGrob(as.raster(readPNG(motif_logo)), interpolate = FALSE)
    img2 <- rasterGrob(as.raster(readPNG(mash_plot)), interpolate = FALSE)
    grid.arrange(img1, img2, ncol = 2)
    # cat(motif_logo, mash_plot, '\n')
    # df.sub[i, ] %>% kable(format = "html", col.names = colnames(df.sub)) %>%
    #   kable_styling() %>%
    #   kableExtra::scroll_box(width = "100%", height = "200px")
    cat('\n', '\n')
}

2 WDR59 COT2_HUMAN.H11MO.1.A

gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
WDR59	ENSG00000103091	16_74937232_T_A_b37	16_74938857_G_A_b37	0.6468	MA0512.2	Rxra	13	14	negative	Heart_Atrial_Appendage

3 TMA7 COT2_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
2	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Heart_Atrial_Appendage

4 TMA7 MA0512.2

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
3	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Heart_Atrial_Appendage

5 GNB4 MA0677.1

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
4	GNB4	ENSG00000114450	3_179172979_G_T_b37	3_179168958_T_C_b37	0.5028	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Atrial_Appendage

6 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
5	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	SP1_HUMAN.H11MO.1.A	NA	7	14	positive	Heart_Atrial_Appendage

7 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
6	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	SP1_HUMAN.H11MO.1.A	NA	12	14	positive	Heart_Atrial_Appendage

8 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
7	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	SP1_HUMAN.H11MO.0.A	NA	12	22	positive	Heart_Atrial_Appendage

9 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
8	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	SP1_HUMAN.H11MO.0.A	NA	7	22	positive	Heart_Atrial_Appendage

10 RIC8A MEF2A_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
9	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	SP1_HUMAN.H11MO.0.A	NA	17	22	positive	Heart_Atrial_Appendage

11 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
10	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5706	SP1_HUMAN.H11MO.1.A	NA	12	14	positive	Heart_Atrial_Appendage

12 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
11	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5706	SP1_HUMAN.H11MO.0.A	NA	17	22	positive	Heart_Atrial_Appendage

13 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
12	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5706	SP1_HUMAN.H11MO.0.A	NA	12	22	positive	Heart_Atrial_Appendage

14 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
13	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5706	SP1_HUMAN.H11MO.0.A	NA	22	22	positive	Heart_Atrial_Appendage

15 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
14	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Heart_Atrial_Appendage

16 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
15	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Atrial_Appendage

17 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
16	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Heart_Atrial_Appendage

18 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
17	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Atrial_Appendage

19 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
18	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Atrial_Appendage

20 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
19	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Heart_Atrial_Appendage

21 PRKCA SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
20	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.9084	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Heart_Atrial_Appendage

22 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
21	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.9084	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Heart_Atrial_Appendage

23 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
22	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7073	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Heart_Atrial_Appendage

24 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
23	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7073	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Heart_Atrial_Appendage

25 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
24	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7073	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Atrial_Appendage

26 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
25	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7073	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Heart_Atrial_Appendage

27 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
26	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Atrial_Appendage

28 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
27	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Heart_Atrial_Appendage

29 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
28	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9832	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Atrial_Appendage

30 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
29	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9832	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Atrial_Appendage

31 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
30	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	MA0079.3	SP1	11	11	negative	Heart_Atrial_Appendage

32 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
31	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	MA0079.3	SP1	5	11	negative	Heart_Atrial_Appendage

33 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
32	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5548	MA0079.3	SP1	0	11	negative	Heart_Atrial_Appendage

34 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
33	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5706	MA0079.3	SP1	1	11	negative	Heart_Atrial_Appendage

35 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
34	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Heart_Atrial_Appendage

36 WDR59 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
35	WDR59	ENSG00000103091	16_74937232_T_A_b37	16_74938857_G_A_b37	0.7172	MA0512.2	Rxra	13	14	negative	Heart_Left_Ventricle

37 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
36	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Heart_Left_Ventricle

38 TMA7 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
37	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Heart_Left_Ventricle

39 GNB4 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
38	GNB4	ENSG00000114450	3_179172979_G_T_b37	3_179168958_T_C_b37	0.5479	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Left_Ventricle

40 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
39	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	SP1_HUMAN.H11MO.1.A	NA	7	14	positive	Heart_Left_Ventricle

41 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
40	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	SP1_HUMAN.H11MO.1.A	NA	12	14	positive	Heart_Left_Ventricle

42 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
41	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	SP1_HUMAN.H11MO.0.A	NA	12	22	positive	Heart_Left_Ventricle

43 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
42	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	SP1_HUMAN.H11MO.0.A	NA	7	22	positive	Heart_Left_Ventricle

44 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
43	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	SP1_HUMAN.H11MO.0.A	NA	17	22	positive	Heart_Left_Ventricle

45 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
44	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5513	SP1_HUMAN.H11MO.1.A	NA	12	14	positive	Heart_Left_Ventricle

46 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
45	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5513	SP1_HUMAN.H11MO.0.A	NA	17	22	positive	Heart_Left_Ventricle

47 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
46	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5513	SP1_HUMAN.H11MO.0.A	NA	12	22	positive	Heart_Left_Ventricle

48 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
47	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5513	SP1_HUMAN.H11MO.0.A	NA	22	22	positive	Heart_Left_Ventricle

49 CDH24 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
48	CDH24	ENSG00000139880	14_23515986_A_T_b37	14_23525653_G_A_b37	0.5152	SP1_HUMAN.H11MO.0.A	NA	6	22	positive	Heart_Left_Ventricle

50 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
49	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Heart_Left_Ventricle

51 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
50	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Left_Ventricle

52 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
51	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Heart_Left_Ventricle

53 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
52	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Left_Ventricle

54 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
53	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Left_Ventricle

55 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
54	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Heart_Left_Ventricle

56 PRKCA SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
55	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.8786	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Heart_Left_Ventricle

57 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
56	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.8786	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Heart_Left_Ventricle

58 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
57	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7685	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Heart_Left_Ventricle

59 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
58	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7685	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Heart_Left_Ventricle

60 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
59	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7685	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Left_Ventricle

61 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
60	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7685	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Heart_Left_Ventricle

62 SIPA1L3 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
61	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Left_Ventricle

63 SIPA1L3 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
62	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Heart_Left_Ventricle

64 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
63	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9807	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Left_Ventricle

65 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
64	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9807	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Left_Ventricle

66 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
65	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	MA0079.3	SP1	11	11	negative	Heart_Left_Ventricle

67 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
66	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	MA0079.3	SP1	5	11	negative	Heart_Left_Ventricle

68 RIC8A SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
67	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207693_CG_C_b37	0.5375	MA0079.3	SP1	0	11	negative	Heart_Left_Ventricle

69 RIC8A SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
68	RIC8A	ENSG00000177963	11_246370_C_T_b37	11_207698_C_T_b37	0.5513	MA0079.3	SP1	1	11	negative	Heart_Left_Ventricle

70 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
69	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Heart_Left_Ventricle

71 WDR59 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
70	WDR59	ENSG00000103091	16_74937232_T_A_b37	16_74938857_G_A_b37	0.6947	MA0512.2	Rxra	13	14	negative	Muscle_Skeletal

72 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
71	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	1	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Muscle_Skeletal

73 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
72	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Muscle_Skeletal

74 GNB4 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
73	GNB4	ENSG00000114450	3_179172979_G_T_b37	3_179168958_T_C_b37	0.5507	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Muscle_Skeletal

75 CDH24 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
74	CDH24	ENSG00000139880	14_23515986_A_T_b37	14_23525653_G_A_b37	0.5342	SP1_HUMAN.H11MO.0.A	NA	6	22	positive	Muscle_Skeletal

76 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
75	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Muscle_Skeletal

77 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
76	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Muscle_Skeletal

78 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
77	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Muscle_Skeletal

79 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
78	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Muscle_Skeletal

80 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
79	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Muscle_Skeletal

81 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
80	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Muscle_Skeletal

82 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
81	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.8875	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Muscle_Skeletal

83 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
82	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	-0.8875	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Muscle_Skeletal

84 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
83	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7216	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Muscle_Skeletal

85 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
84	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7216	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Muscle_Skeletal

86 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
85	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7216	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Muscle_Skeletal

87 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
86	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.7216	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Muscle_Skeletal

88 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
87	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9997	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Muscle_Skeletal

89 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
88	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9997	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Muscle_Skeletal

90 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
89	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.985	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Muscle_Skeletal

91 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
90	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.985	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Muscle_Skeletal

92 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
91	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	1	MA0079.3	SP1	11	11	negative	Muscle_Skeletal

93 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
92	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Muscle_Skeletal